package com.eduction.service.impl;

import java.sql.SQLException;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.eduction.modules.system.dao.SiteInspectionExpertGroupMapRspository;
import com.eduction.modules.system.entity.ExpertGroupMap;
import com.eduction.service.ExpertGroupMapService;

@Service
public class ExpertGroupMapServiceImpl implements ExpertGroupMapService{

	@Autowired
	private SiteInspectionExpertGroupMapRspository expertGroupMapRspository;
	
	@Override
	public ExpertGroupMap queryGroupByExpertId(String expertId,String type) throws SQLException {
		ExpertGroupMap eg = expertGroupMapRspository.queryGroupByExpertId(expertId,type);
		return eg;
	}
	@Override
	public void deleteBySchoolIdAndExpertId(String schoolId, String expertId) throws SQLException {
		expertGroupMapRspository.deleteBySchoolIdAndExpertId(schoolId,expertId);
	}
	@Override
	public List<ExpertGroupMap> querySchoolByGroupId(String groupId) throws SQLException{
		return expertGroupMapRspository.querySchoolByGroupId(groupId);
	}
}
